Introduction

Here is a study of timeseries to evaluate the data we have and be able to discretize the time.

Index:

  • Speed.
  • Intersession time.
  • Standard deviation.

With this first approach we can see the almost total absence of points on the weekends. Also, very few points at night in all edges. Most points are under 50km/h.

Timeseries

Speed Boxplot.

Median is under 5km/h for every hour and percentile 75 under 30km/h. At 13h is the time with less difference and lowest speed records.

Boxplot intersession time

The intersession time median it is not even under 60min for every edge. Frei’s st. shows an intersession time way smaller than the rest.

All speed timeseries per way_id

Avg speed by session and then time.

[[1]]

[[2]]

[[3]]

[[4]]

[[5]]

[[6]]

[[7]]

[[8]]

[[9]]

Hour

Week day

Day

Average of speed of every point.

Number of sessions

  • We can see usually a incremental of number of sessions along the week. Being thursdays and fridays the one with most sessions. *The drop in day 25th it is because holiday.
[[1]]


[[2]]


[[3]]


[[4]]


[[5]]


[[6]]


[[7]]


[[8]]


[[9]]

NA

Average speed

[[1]]


[[2]]


[[3]]


[[4]]


[[5]]


[[6]]


[[7]]


[[8]]


[[9]]

NA

Intersession time

Error in df_intersession_april16pt %>% filter(way_id == df_osm_edge_ids[index,  : 
  could not find function "%>%"

Density lines average speed all together

Standard deviation

By hour

By day and hour

By session

–>

LS0tCnRpdGxlOiAiVGltZXNlcmllcyBhbmFseXNpcyB0b3AgZWRnZXMiCm91dHB1dDogCiAgaHRtbF9ub3RlYm9vazoKICB0b2M6IHRydWUKLS0tCgojIEludHJvZHVjdGlvbiAKCkhlcmUgaXMgYSBzdHVkeSBvZiB0aW1lc2VyaWVzIHRvIGV2YWx1YXRlIHRoZSBkYXRhIHdlIGhhdmUgYW5kIGJlIGFibGUgdG8gZGlzY3JldGl6ZQp0aGUgdGltZS4gCgojIyMjIEluZGV4OiAKCiAgKiBTcGVlZC4KICAqIEludGVyc2Vzc2lvbiB0aW1lLgogICogU3RhbmRhcmQgZGV2aWF0aW9uLiAKCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCgpgYGB7ciBlY2hvPUZBTFNFfQpzb3VyY2UoIi4uL3JzY3JpcHRzL3BhY2thZ2VzLlIiKQpzb3VyY2UoIi4uL3JzY3JpcHRzL3RpbWVzZXJpZXMuUiIpCmBgYAoKV2l0aCB0aGlzIGZpcnN0IGFwcHJvYWNoIHdlIGNhbiBzZWUgdGhlIGFsbW9zdCB0b3RhbCBhYnNlbmNlIG9mIHBvaW50cyAgb24gdGhlIHdlZWtlbmRzLiAKQWxzbywgdmVyeSBmZXcgcG9pbnRzIGF0IG5pZ2h0IGluIGFsbCBlZGdlcy4gCk1vc3QgcG9pbnRzIGFyZSB1bmRlciA1MGttL2guCgpgYGB7ciBlY2hvPUZBTFNFfQpsYXBwbHkoMTo5LCBGVU4gPSB0c2VyaWVzX2xpZ2h0KQpgYGAKCiNUaW1lc2VyaWVzIAoKIyMgU3BlZWQgQm94cGxvdC4KCk1lZGlhbiBpcyB1bmRlciA1a20vaCBmb3IgZXZlcnkgaG91ciBhbmQgcGVyY2VudGlsZSA3NSB1bmRlciAzMGttL2guCkF0IDEzaCBpcyB0aGUgdGltZSB3aXRoIGxlc3MgZGlmZmVyZW5jZSBhbmQgbG93ZXN0IHNwZWVkIHJlY29yZHMuIApgYGB7ciBlY2hvPUZBTFNFfQojQm94cGxvdHMgYWxsIApkZl9zdXBlcmhvdGVkZ2VzX2FwcmlsMTZwdCAlPiUgCiAgZmlsdGVyKHNwZWVkID4gMCwgd2RheSh0aW1lKSAhPSAxICwgd2RheSh0aW1lKSAhPSA3ICkgJT4lIAogIGdyb3VwX2J5KGhvdXIgPSBob3VyKHRpbWUpKSAlPiUgCiAgcGxvdF9seSh4PSB+ZmFjdG9yKGhvdXIpLCB5PSB+KHNwZWVkKjE4KS81LCB0eXBlID0gJ2JveCcsYm94cG9pbnRzID0gRkFMU0UpICU+JSAKICBsYXlvdXQodGl0bGUgPSBwYXN0ZSgiQXZnIHNwZWVkIHBlciBob3VyIChXVykiICksCiAgICAgICAgIHlheGlzID0gbGlzdCh0aXRsZT0iU3BlZWQgKGttL2gpIiksCiAgICAgICAgIHhheGlzID0gbGlzdCh0aXRsZT0iSG91ciIpKQpgYGAKCgojIyBCb3hwbG90IGludGVyc2Vzc2lvbiB0aW1lICAKClRoZSBpbnRlcnNlc3Npb24gdGltZSBtZWRpYW4gaXQgaXMgbm90IGV2ZW4gdW5kZXIgNjBtaW4gZm9yIGV2ZXJ5IGVkZ2UuCkZyZWkncyBzdC4gc2hvd3MgYW4gaW50ZXJzZXNzaW9uIHRpbWUgd2F5IHNtYWxsZXIgdGhhbiB0aGUgcmVzdC4gCmBgYHtyIGVjaG89RkFMU0V9CiNCb3hwbG90cyBhbGwgCmRmX2ludGVyc2Vzc2lvbl9hcHJpbDE2cHQgJT4lCiAgc3Vic2V0KHdheV9pZCAlaW4lIGRmX3N1cGVyaG90ZWRnZXNfYXByaWwxNnB0JHdheV9pZCkgJT4lIAogIG1lcmdlKHkgPSBkZl9vc21fZWRnZV9pZHMsIHVzaW5nID0gd2F5X2lkKSAlPiUgCiAgZ2dwbG90KGFlcyhmYWN0b3IoYWRkcmVzcyksIGludGVyc2Vzc2lvbl90aW1lKSkgKwogIGdlb21fYm94cGxvdCgpICsKICBjb29yZF9jYXJ0ZXNpYW4oeWxpbT0gYygwLDI1MCkpKwogIGdndGl0bGUobGFiZWwgPSAiSW50ZXJzZXNzaW9uIHRpbWUgdG9wIGVkZ2VzIikgKyAKICB4bGFiKCIiKSArIAogIHlsYWIoIlRpbWUgKG1pbikiKSArCiAgdGhlbWUoYXhpcy50ZXh0Lng9ZWxlbWVudF90ZXh0KGFuZ2xlPTQ1LGhqdXN0PTEsdmp1c3Q9MSkpCmBgYAoKCgoKIyMgQWxsIHNwZWVkIHRpbWVzZXJpZXMgcGVyIHdheV9pZAoKIyMjIEF2ZyBzcGVlZCBieSBzZXNzaW9uIGFuZCB0aGVuIHRpbWUuCgpgYGB7ciBlY2hvPUZBTFNFLCBtZXNzYWdlPUZBTFNFLCB3YXJuaW5nPUZBTFNFfQpsYXBwbHkoMTo5LEZVTiA9IHBsb3QudGltZXNlcmllcykgCmBgYAoKIyMjIyBIb3VyCmBgYHtyIGVjaG89RkFMU0UsIG1lc3NhZ2U9RkFMU0UsIHdhcm5pbmc9RkFMU0V9CnBsb3Quc3BlZWRfYXZnKGRmX3N1cGVyaG90ZWRnZXNfYXByaWwxNnB0LCBob3VyKQpgYGAKCiMjIyMgV2VlayBkYXkKYGBge3IgZWNobz1GQUxTRSwgbWVzc2FnZT1GQUxTRSwgd2FybmluZz1GQUxTRX0KcGxvdC5zcGVlZF9hdmcoZGZfc3VwZXJob3RlZGdlc19hcHJpbDE2cHQsIHdkYXkpCmBgYAoKIyMjIyBEYXkKYGBge3IgZWNobz1GQUxTRSwgbWVzc2FnZT1GQUxTRSwgd2FybmluZz1GQUxTRX0KcGxvdC5zcGVlZF9hdmcoZGZfc3VwZXJob3RlZGdlc19hcHJpbDE2cHQsIGRheSkKYGBgCgoKIyMjQXZlcmFnZSBvZiBzcGVlZCBvZiBldmVyeSBwb2ludC4KIyMjI051bWJlciBvZiBzZXNzaW9ucyAKCiAgKiBXZSBjYW4gc2VlIHVzdWFsbHkgYSBpbmNyZW1lbnRhbCBvZiBudW1iZXIgb2Ygc2Vzc2lvbnMgYWxvbmcgdGhlIHdlZWsuIEJlaW5nIAogIHRodXJzZGF5cyBhbmQgZnJpZGF5cyB0aGUgb25lIHdpdGggbW9zdCBzZXNzaW9ucy4gCiAgKlRoZSBkcm9wIGluIGRheSAyNXRoIGl0IGlzIGJlY2F1c2UgaG9saWRheS4KCmBgYHtyIGVjaG89RkFMU0UsIG1lc3NhZ2U9RkFMU0V9CmxhcHBseSgxOjksIEZVTiA9IHRzZXJpZXNfbnNlc3Npb24pCmBgYAoKIyMjIEF2ZXJhZ2Ugc3BlZWQKYGBge3IgZWNobz1GQUxTRSwgbWVzc2FnZT1GQUxTRX0KbGFwcGx5KDE6OSwgRlVOID0gdHNlcmllc19zcGVlZCkKYGBgCgojIyNJbnRlcnNlc3Npb24gdGltZQpgYGB7ciBlY2hvPUZBTFNFLCBtZXNzYWdlPUZBTFNFLCB3YXJuaW5nPUZBTFNFfQpsYXBwbHkoMTo5LCBGVU4gPSB0c2VyaWVzX2ludGVyKQpgYGAKCiMjRGVuc2l0eSBsaW5lcyBhdmVyYWdlIHNwZWVkIGFsbCB0b2dldGhlcgpgYGB7ciBlY2hvPUZBTFNFfQpnZ3Bsb3RseShkZW5zKQpgYGAKIyMgU3RhbmRhcmQgZGV2aWF0aW9uCgojIyMgQnkgaG91cgpgYGB7ciBlY2hvPUZBTFNFfQpkZl9zdXBlcmhvdGVkZ2VzX2FwcmlsMTZwdCAlPiUgCiAgZmlsdGVyKCB3ZGF5KHRpbWUpICE9IDEgLCB3ZGF5KHRpbWUpICE9IDcgKSAlPiUgCiAgZ3JvdXBfYnkod2F5X2lkLHNlc3Npb25faWQsIGhvdXIgPSBob3VyKHRpbWUpLCBoZWFkaW5nKSAlPiUKICBzdW1tYXJpc2Uoc3BlZWRfc2VzcyA9IG1lYW4oc3BlZWQqMTgvNSkpICU+JQogIGdyb3VwX2J5KHdheV9pZCwgaG91ciwgaGVhZGluZykgJT4lCiAgc3VtbWFyaXNlKGF2Z19zcGVlZCA9IG1lYW4oc3BlZWRfc2VzcyksIHNkID0gc2Qoc3BlZWRfc2VzcykpICU+JSAKICBtZXJnZSh5ID0gZGZfb3NtX2VkZ2VfaWRzLCB1c2luZyA9IHdheV9pZCkgJT4lIAogIGdncGxvdChhZXMoeD1hdmdfc3BlZWQsIHk9c2QsIGNvbG9yID0gaGVhZGluZykpICsKICBnZW9tX3BvaW50KCkgKwogIGdlb21fc21vb3RoKCkgKwogIGZhY2V0X3dyYXAofiBhZGRyZXNzKSArIAogIGdndGl0bGUoIkJ5IGhvdXIgYXZnLiBzcGVlZCBBcHJpbDE2IikKYGBgCgojIyMgQnkgZGF5IGFuZCBob3VyCmBgYHtyIGVjaG89RkFMU0V9CmRmX3N1cGVyaG90ZWRnZXNfYXByaWwxNnB0ICU+JSAKICBmaWx0ZXIoIHdkYXkodGltZSkgIT0gMSAsIHdkYXkodGltZSkgIT0gNyApICU+JSAKICBncm91cF9ieSh3YXlfaWQsc2Vzc2lvbl9pZCwgZGF5ID0gd2RheSh0aW1lKSwgaG91ciA9IGhvdXIodGltZSksIGhlYWRpbmcpICU+JSAKICBzdW1tYXJpc2Uoc3BlZWRfc2VzcyA9IG1lYW4oc3BlZWQqMTgvNSkpICU+JSAKICBncm91cF9ieSh3YXlfaWQsIGRheSwgaG91ciwgaGVhZGluZykgJT4lIAogIHN1bW1hcmlzZShhdmdfc3BlZWQgPSBtZWFuKHNwZWVkX3Nlc3MpLCBzZD0gc2Qoc3BlZWRfc2VzcykpICU+JSAKICBtZXJnZSh5ID0gZGZfb3NtX2VkZ2VfaWRzLCB1c2luZyA9IHdheV9pZCkgJT4lIAogIGdncGxvdChhZXMoeD1hdmdfc3BlZWQsIHk9c2QsIGNvbG9yID0gaGVhZGluZykpICsKICBnZW9tX3BvaW50KGFscGhhID0gMS8zKSArCiAgZ2VvbV9zbW9vdGgoKSArCiAgZmFjZXRfd3JhcCh+IGFkZHJlc3MpICsgCiAgZ2d0aXRsZSgiQnkgZGF5IGFuZCBob3VyIGF2Zy5zcGVlZCIpCmBgYAoKIyMjIEJ5IHNlc3Npb24gCmBgYHtyIGVjaG89RkFMU0V9CmRmX3N1cGVyaG90ZWRnZXNfYXByaWwxNnB0ICU+JSAKICBncm91cF9ieSh3YXlfaWQsIHNlc3Npb25faWQsIGhvdXIgPSBob3VyKHRpbWUpLCBoZWFkaW5nKSAlPiUgCiAgc3VtbWFyaXNlKGF2Z19zcGVlZCA9IG1lYW4oc3BlZWQqMTgvNSksIHNkID0gc2Qoc3BlZWQpKSAlPiUgCiAgbWVyZ2UoeSA9IGRmX29zbV9lZGdlX2lkcywgdXNpbmcgPSB3YXlfaWQpICU+JSAKICBnZ3Bsb3QoYWVzKHg9YXZnX3NwZWVkLCB5PXNkLCBjb2xvciA9IGhlYWRpbmcpKSArCiAgZ2VvbV9wb2ludChhbHBoYSA9IDEvNSkgKwogIGdlb21fc21vb3RoKGFlcyhjb2xvdXIgPSBoZWFkaW5nLCBmaWxsID0gaGVhZGluZykpICsKICBmYWNldF93cmFwKH5hZGRyZXNzKSArIAogIGdndGl0bGUoIkJ5IHNlc3Npb24gcGVyIGhvdXIgYXZnLiBzcGVlZCBBcHJpbDE2IikKYGBgCgo8IS0tCiMjIEFsbCBzcGVlZCB0aW1lc2VyaWVzIHBlciB3YXlfaWQKQXZlcmFnZSBvZiBzcGVlZCBvZiBldmVyeSBwb2ludC4KCmBgYHtyIGVjaG89RkFMU0UsIG1lc3NhZ2U9RkFMU0V9CmxhcHBseSgxOjksIEZVTiA9IHRzZXJpZXMpCmBgYAotLT4KCgoKCg==